{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["USER GUIDE","CONVERTER","Sheet1"],"not_rendered":{"images":15,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":74,"n_cols":36,"rows_kept":74,"merged":[[1,1,3,3]]}
[]
[null,"User Guide",{"$nulls":3},"Important Note:",null,"Please enable macro to use this file.",{"$nulls":4},"To enable macro:",{"$nulls":22},{"$f":"IF((COUNT(X:X)+1)<2,\"\",(COUNT(X:X)+1))","v":""}]
[{"$nulls":5},"To view the Developer tab:",{"$nulls":6},"Go to Developer tab>>Macro Security>>Enable All Macro>>OK"]
[{"$nulls":5},"Go to File>>Options>>Customize Ribbon>>Check Developer>>OK",{"$nulls":6},">>Save>>Close the file>>Re-open the file",{"$nulls":6},"V.0"]
[]
[null,"STEP 1:"]
[]
[null,"Download broker order history report"]
{"$rows_empty":10}
[null,"STEP 2:"]
[null,"Go to \"CONVERTER\" sheet and click \"SELECT SOURCE FILE\", locate your Order History file, and click OK"]
{"$rows_empty":15}
[null,"STEP 3:"]
[null,"Click COPY icon from CONVERTER sheet."]
{"$rows_empty":11}
[null,"STEP 5:"]
[null,"Paste your trade data in your Trading Journal"]
{"$rows_empty":23}
[null,"You can check out the sample of our trading journal below, contact us or visit our website for more info."]

{"sheet":"CONVERTER","index":1,"n_rows":7,"n_cols":35,"rows_kept":7}
[{"$nulls":5},{"$f":"IF(COUNTA(Sheet1!B:B)<8,8,COUNTA(Sheet1!C:C)+20)","v":8},{"$f":"IF(COUNT(U:U)+5<6,6,COUNT(U:U)+5)","v":6},null,{"$f":"\"u\"&COUNT(U:U)+5","v":"u5"},{"$nulls":11},"Developed by Rocketsheets, Binance Ledger Converter v.0"]
[]
[]
[]
[null,"No.","fee value","trade#","total fee",null,"date value","match","Date","Pair","type","Price","share","fee","share","total fee","total",{"$nulls":3},"DATE","PAIR","ACTION","PRICE","SHARES","FEES",{"$nulls":7},"28/04/20",{"$f":"VALUE(AH5)","v":{"$error":"#VALUE!"}}]
[null,1,{"$f":"IFERROR(IF(Sheet1!A2<>\"\",\"\",VALUE(LEFT(Sheet1!F2,10))),\"\")","v":""},{"$f":"IF(Sheet1!A2<>\"\",1,0)","v":0},{"$f":"SUMIF(D$5:D$99999,D6,C$5:C$99999)","v":0},1,{"$f":"IF(Sheet1!A2=\"\",\"\",VALUE(Sheet1!A2))","v":""},{"$f":"MATCH(I6,G$6:G$99999,0)","v":{"$error":"#NUM!"}},{"$f":"SMALL(G$6:G$99999,F6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B$2:B$99999,$H6)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!C$2:C$99999,$H6)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!F$2:F$99999,$H6))","v":{"$error":"#NUM!"}},{"$f":"IF(K6=\"buy\",O6-P6,O6)","v":{"$error":"#NUM!"}},{"$f":"IF(K6=\"buy\",0,P6*L6)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!G$2:G$99999,$H6))","v":{"$error":"#NUM!"}},{"$f":"INDEX(E$6:E$99999,H6)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!H$2:H$99999,$H6))","v":{"$error":"#NUM!"}},{"$nulls":3},{"$f":"IFERROR(I6,\"\")","v":""},"","","","",""]
[null,{"$f":"B6+1","v":2},{"$f":"IFERROR(IF(Sheet1!A3<>\"\",\"\",VALUE(LEFT(Sheet1!F3,10))),\"\")","v":""},{"$f":"IF(Sheet1!A3=\"\",D6,IF(Sheet1!A3<>\"\",D6+1,0))","v":0},{"$f":"SUMIF(D$5:D$99999,D7,C$5:C$99999)","v":0},{"$f":"F6+1","v":2},{"$f":"IF(Sheet1!A3=\"\",\"\",VALUE(Sheet1!A3))","v":""},{"$f":"MATCH(I7,G$6:G$99999,0)","v":{"$error":"#NUM!"}},{"$f":"SMALL(G$6:G$99999,F7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!B$2:B$99999,$H7)","v":{"$error":"#NUM!"}},{"$f":"INDEX(Sheet1!C$2:C$99999,$H7)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!F$2:F$99999,$H7))","v":{"$error":"#NUM!"}},{"$f":"IF(K7=\"buy\",O7-P7,O7)","v":{"$error":"#NUM!"}},{"$f":"IF(K7=\"buy\",0,P7*L7)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!G$2:G$99999,$H7))","v":{"$error":"#NUM!"}},{"$f":"INDEX(E$6:E$99999,H7)","v":{"$error":"#NUM!"}},{"$f":"VALUE(INDEX(Sheet1!H$2:H$99999,$H7))","v":{"$error":"#NUM!"}},{"$nulls":3},{"$f":"IFERROR(I7,\"\")","v":""},{"$f":"IFERROR(J7,\"\")","v":""},{"$f":"IFERROR(K7,\"\")","v":""},{"$f":"IFERROR(L7,\"\")","v":""},{"$f":"IFERROR(M7,\"\")","v":""},{"$f":"IFERROR(N7,\"\")","v":""}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}